Skip to main content

ApiPivotDataField

Represents the ApiPivotDataField class.

Properties

NameTypeDescription
FunctionDataConsolidateFunctionTypeReturns or sets a function for the data field.
PositionnumberReturns or sets a value that represents the data field position within a category.
OrientationPivotFieldOrientationTypeReturns a data field orientation value that represents the data field location in the specified pivot table report.
NamestringReturns or sets a value representing the object name.
ValuestringReturns or sets a value representing the name of the specified data field in the pivot table report.
CaptionstringReturns or sets a value that represents the label text for the data field.
NumberFormatstringnull
IndexnumberReturns an index of the data field.
PivotFieldApiPivotFieldReturns the pivot field from which the data field was created.

Methods